﻿CREATE TABLE [dbo].[UDS_Linkman_CustomLinkman] (
    [ID]              int           NOT NULL identity(1, 1),
    [Name]            nvarchar(100)  COLLATE Chinese_PRC_CI_AS NULL,
    [Gender]          bit           NOT NULL,
    [UnitTelephone]   nvarchar(50)   COLLATE Chinese_PRC_CI_AS NULL,
    [Email]           nvarchar(50)   COLLATE Chinese_PRC_CI_AS NULL,
    [UnitAddress]     nvarchar(200)  COLLATE Chinese_PRC_CI_AS NULL,
    [UnitZip]         nvarchar(50)   COLLATE Chinese_PRC_CI_AS NULL,
    [FamilyAddress]   nvarchar(200)  COLLATE Chinese_PRC_CI_AS NULL,
    [FamilyZip]       nvarchar(50)   COLLATE Chinese_PRC_CI_AS NULL,
    [Mobile]          nvarchar(100)  COLLATE Chinese_PRC_CI_AS NULL,
    [FamilyTelephone] nvarchar(50)   COLLATE Chinese_PRC_CI_AS NULL,
    [Memo]            nvarchar(1000) COLLATE Chinese_PRC_CI_AS NULL,
    [Age]             nvarchar(50)   COLLATE Chinese_PRC_CI_AS NULL,

    CONSTRAINT [PK_UDS_Linkman_CustomLinkman] PRIMARY KEY CLUSTERED ([ID] asc)
);
GO
